<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Working with multiple datasets</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nCreating and formatting a document\nAdding and editing text and data in a document\nAdding your warehouse data to a document: Dataset reports\nWorking with multiple datasets");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Working with multiple datasets</h1>
<p>When documents contain multiple datasets, Intelligence Server joins 
 the data in the datasets using a compound join. </p>
<ul type="disc" class="whs1">
	
<li class=p><p>If the datasets have any of the same attributes, the 
 common attribute elements are matched. </p></li>
	
<li class=p><p>Then beginning with the first row of each dataset and 
 continuing to the last, a row is created in a virtual dataset, that is, 
 the complete set of joined rows held in memory, consisting of all attributes, 
 consolidations, custom groups, and metrics.</p></li>
</ul>
<p>Metrics come from their respective datasets and exist only at the level 
 of that dataset. The compound join saves memory space and processing time 
 on the Intelligence Server executing the document.</p>
<p>When there are multiple datasets in a document, the grouping and sorting 
 dataset is the one that is bold in the Dataset Objects panel. A document 
 can be grouped and sorted using fields from the primary dataset only.</p>
<h3>Related topics</h3>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Add_dataset_to_document.htm">Adding and removing 
 a dataset</a></p></li>
	
<li class=p><p>
<a HREF="Subset_report_as_dataset.htm">Using a subset 
 report as a dataset</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
